
--- Update Trang Thai Gui Mail Da Thu Tien ---

Declare @KhoaPhieuGhiDanh bigint
SET @KhoaPhieuGhiDanh = 1

UPDATE PhieuGhiDanh
SET TrangThaiGuiMailDaThuTien = 1
WHERE Khoa = @KhoaPhieuGhiDanh AND TrangThaiPhieuGhiDanh = 3

